Overview
Brought to you by YData
Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 124494 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 1 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 25.2 MiB |
| Average record size in memory | 212.0 B |
Variable types
| DateTime | 1 |
|---|---|
| Text | 1 |
| Categorical | 1 |
| Numeric | 9 |
| Dataset has 1 (< 0.1%) duplicate rows | Duplicates |
attribute7 is highly overall correlated with attribute8 | High correlation |
attribute8 is highly overall correlated with attribute7 | High correlation |
failure is highly imbalanced (99.0%) | Imbalance |
attribute2 is highly skewed (γ1 = 23.8579234) | Skewed |
attribute3 is highly skewed (γ1 = 82.712278) | Skewed |
attribute4 is highly skewed (γ1 = 41.50261118) | Skewed |
attribute7 is highly skewed (γ1 = 73.47645637) | Skewed |
attribute8 is highly skewed (γ1 = 73.47645637) | Skewed |
attribute9 is highly skewed (γ1 = 49.89927809) | Skewed |
attribute2 has 118110 (94.9%) zeros | Zeros |
attribute3 has 115359 (92.7%) zeros | Zeros |
attribute4 has 115156 (92.5%) zeros | Zeros |
attribute7 has 123036 (98.8%) zeros | Zeros |
attribute8 has 123036 (98.8%) zeros | Zeros |
attribute9 has 97358 (78.2%) zeros | Zeros |
Reproduction
| Analysis started | 2024-12-06 04:29:16.146921 |
|---|---|
| Analysis finished | 2024-12-06 04:29:35.138370 |
| Duration | 18.99 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
date
Date
| Distinct | 304 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 972.7 KiB |
| Minimum | 2015-01-01 00:00:00 |
|---|---|
| Maximum | 2015-11-02 00:00:00 |
Histogram with fixed size bins (bins=50)
device
Text
| Distinct | 1169 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.7 MiB |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | S1F01085 |
|---|---|
| 2nd row | S1F0166B |
| 3rd row | S1F01E6Y |
| 4th row | S1F01JE0 |
| 5th row | S1F01R2B |
| Value | Count | Frequency (%) |
| z1f0qlc1 | 304 | 0.2% |
| w1f0fzpa | 304 | 0.2% |
| s1f0kycr | 304 | 0.2% |
| z1f0qk05 | 304 | 0.2% |
| z1f0q8rt | 304 | 0.2% |
| z1f0ql3n | 304 | 0.2% |
| w1f0sjj2 | 304 | 0.2% |
| z1f0kjds | 304 | 0.2% |
| z1f0ge1m | 304 | 0.2% |
| z1f0gb8a | 304 | 0.2% |
| Other values (1159) | 121454 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 191997 | |
| F | 138461 | |
| 0 | 91213 | 9.2% |
| S | 76253 | 7.7% |
| W | 54973 | 5.5% |
| Z | 39881 | 4.0% |
| L | 25058 | 2.5% |
| 3 | 23981 | 2.4% |
| K | 18757 | 1.9% |
| B | 17806 | 1.8% |
| Other values (24) | 317572 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 995952 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 191997 | |
| F | 138461 | |
| 0 | 91213 | 9.2% |
| S | 76253 | 7.7% |
| W | 54973 | 5.5% |
| Z | 39881 | 4.0% |
| L | 25058 | 2.5% |
| 3 | 23981 | 2.4% |
| K | 18757 | 1.9% |
| B | 17806 | 1.8% |
| Other values (24) | 317572 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 995952 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 191997 | |
| F | 138461 | |
| 0 | 91213 | 9.2% |
| S | 76253 | 7.7% |
| W | 54973 | 5.5% |
| Z | 39881 | 4.0% |
| L | 25058 | 2.5% |
| 3 | 23981 | 2.4% |
| K | 18757 | 1.9% |
| B | 17806 | 1.8% |
| Other values (24) | 317572 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 995952 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 191997 | |
| F | 138461 | |
| 0 | 91213 | 9.2% |
| S | 76253 | 7.7% |
| W | 54973 | 5.5% |
| Z | 39881 | 4.0% |
| L | 25058 | 2.5% |
| 3 | 23981 | 2.4% |
| K | 18757 | 1.9% |
| B | 17806 | 1.8% |
| Other values (24) | 317572 |
failure
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| 0 | |
|---|---|
| 1 | 106 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 124388 | |
| 1 | 106 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 124388 | |
| 1 | 106 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 124388 | |
| 1 | 106 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 124494 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 124388 | |
| 1 | 106 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 124494 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 124388 | |
| 1 | 106 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 124494 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 124388 | |
| 1 | 106 | 0.1% |
attribute1
Real number (ℝ)
| Distinct | 123877 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.223881 × 108 |
| Minimum | 0 |
|---|---|
| Maximum | 2.4414048 × 108 |
| Zeros | 11 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 972.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 12090104 |
| Q1 | 61284762 |
| median | 1.2279739 × 108 |
| Q3 | 1.8330964 × 108 |
| 95-th percentile | 2.3187385 × 108 |
| Maximum | 2.4414048 × 108 |
| Range | 2.4414048 × 108 |
| Interquartile range (IQR) | 1.2202488 × 108 |
Descriptive statistics
| Standard deviation | 70459334 |
|---|---|
| Coefficient of variation (CV) | 0.57570411 |
| Kurtosis | -1.1993057 |
| Mean | 1.223881 × 108 |
| Median Absolute Deviation (MAD) | 61032236 |
| Skewness | -0.011142964 |
| Sum | 1.5236585 × 1013 |
| Variance | 4.9645178 × 1015 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 57192360 | 26 | < 0.1% |
| 89196552 | 26 | < 0.1% |
| 165048912 | 26 | < 0.1% |
| 169490248 | 23 | < 0.1% |
| 57180136 | 15 | < 0.1% |
| 12194976 | 15 | < 0.1% |
| 89162648 | 15 | < 0.1% |
| 165040624 | 15 | < 0.1% |
| 169467344 | 15 | < 0.1% |
| 165045144 | 13 | < 0.1% |
| Other values (123867) | 124305 |
| Value | Count | Frequency (%) |
| 0 | 11 | |
| 2048 | 1 | < 0.1% |
| 2056 | 2 | < 0.1% |
| 2168 | 1 | < 0.1% |
| 3784 | 1 | < 0.1% |
| 4224 | 1 | < 0.1% |
| 4480 | 1 | < 0.1% |
| 4560 | 1 | < 0.1% |
| 8280 | 1 | < 0.1% |
| 8616 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 244140480 | 1 | |
| 244138600 | 1 | |
| 244136552 | 1 | |
| 244135688 | 1 | |
| 244133240 | 1 | |
| 244132936 | 1 | |
| 244132752 | 1 | |
| 244131712 | 1 | |
| 244129416 | 1 | |
| 244127840 | 1 |
attribute2
Real number (ℝ)
Skewed Zeros
| Distinct | 558 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 159.48476 |
| Minimum | 0 |
|---|---|
| Maximum | 64968 |
| Zeros | 118110 |
| Zeros (%) | 94.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 972.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 8 |
| Maximum | 64968 |
| Range | 64968 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2179.6577 |
|---|---|
| Coefficient of variation (CV) | 13.666871 |
| Kurtosis | 626.82057 |
| Mean | 159.48476 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 23.857923 |
| Sum | 19854896 |
| Variance | 4750907.8 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 118110 | |
| 2344 | 281 | 0.2% |
| 8 | 260 | 0.2% |
| 24 | 254 | 0.2% |
| 40 | 201 | 0.2% |
| 4960 | 175 | 0.1% |
| 424 | 169 | 0.1% |
| 16 | 166 | 0.1% |
| 88 | 152 | 0.1% |
| 552 | 140 | 0.1% |
| Other values (548) | 4586 | 3.7% |
| Value | Count | Frequency (%) |
| 0 | 118110 | |
| 8 | 260 | 0.2% |
| 16 | 166 | 0.1% |
| 24 | 254 | 0.2% |
| 32 | 132 | 0.1% |
| 40 | 201 | 0.2% |
| 48 | 90 | 0.1% |
| 56 | 104 | 0.1% |
| 64 | 26 | < 0.1% |
| 72 | 35 | < 0.1% |
| Value | Count | Frequency (%) |
| 64968 | 1 | < 0.1% |
| 64792 | 7 | |
| 64784 | 11 | |
| 64776 | 8 | |
| 64736 | 13 | |
| 64728 | 13 | |
| 64584 | 17 | |
| 64472 | 1 | < 0.1% |
| 64464 | 1 | < 0.1% |
| 62296 | 1 | < 0.1% |
attribute3
Real number (ℝ)
Skewed Zeros
| Distinct | 47 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.940455 |
| Minimum | 0 |
|---|---|
| Maximum | 24929 |
| Zeros | 115359 |
| Zeros (%) | 92.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 972.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 24929 |
| Range | 24929 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 185.74732 |
|---|---|
| Coefficient of variation (CV) | 18.685998 |
| Kurtosis | 10473.588 |
| Mean | 9.940455 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 82.712278 |
| Sum | 1237527 |
| Variance | 34502.067 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=47)
| Value | Count | Frequency (%) |
| 0 | 115359 | |
| 1 | 3274 | 2.6% |
| 2 | 749 | 0.6% |
| 7 | 298 | 0.2% |
| 34 | 293 | 0.2% |
| 5 | 278 | 0.2% |
| 21 | 269 | 0.2% |
| 4 | 268 | 0.2% |
| 9 | 262 | 0.2% |
| 8 | 251 | 0.2% |
| Other values (37) | 3193 | 2.6% |
| Value | Count | Frequency (%) |
| 0 | 115359 | |
| 1 | 3274 | 2.6% |
| 2 | 749 | 0.6% |
| 3 | 113 | 0.1% |
| 4 | 268 | 0.2% |
| 5 | 278 | 0.2% |
| 7 | 298 | 0.2% |
| 8 | 251 | 0.2% |
| 9 | 262 | 0.2% |
| 10 | 241 | 0.2% |
| Value | Count | Frequency (%) |
| 24929 | 4 | < 0.1% |
| 2693 | 179 | |
| 2112 | 6 | < 0.1% |
| 1331 | 240 | |
| 1326 | 5 | < 0.1% |
| 1162 | 1 | < 0.1% |
| 406 | 84 | 0.1% |
| 382 | 5 | < 0.1% |
| 377 | 6 | < 0.1% |
| 323 | 6 | < 0.1% |
attribute4
Real number (ℝ)
Skewed Zeros
| Distinct | 115 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.7411201 |
| Minimum | 0 |
|---|---|
| Maximum | 1666 |
| Zeros | 115156 |
| Zeros (%) | 92.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 972.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 6 |
| Maximum | 1666 |
| Range | 1666 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 22.908507 |
|---|---|
| Coefficient of variation (CV) | 13.157339 |
| Kurtosis | 2467.9628 |
| Mean | 1.7411201 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 41.502611 |
| Sum | 216759 |
| Variance | 524.79967 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 115156 | |
| 6 | 3681 | 3.0% |
| 1 | 889 | 0.7% |
| 2 | 711 | 0.6% |
| 3 | 466 | 0.4% |
| 12 | 454 | 0.4% |
| 4 | 359 | 0.3% |
| 10 | 294 | 0.2% |
| 112 | 245 | 0.2% |
| 5 | 231 | 0.2% |
| Other values (105) | 2008 | 1.6% |
| Value | Count | Frequency (%) |
| 0 | 115156 | |
| 1 | 889 | 0.7% |
| 2 | 711 | 0.6% |
| 3 | 466 | 0.4% |
| 4 | 359 | 0.3% |
| 5 | 231 | 0.2% |
| 6 | 3681 | 3.0% |
| 7 | 175 | 0.1% |
| 8 | 170 | 0.1% |
| 9 | 45 | < 0.1% |
| Value | Count | Frequency (%) |
| 1666 | 9 | |
| 1074 | 6 | < 0.1% |
| 1033 | 3 | < 0.1% |
| 841 | 1 | < 0.1% |
| 763 | 1 | < 0.1% |
| 533 | 1 | < 0.1% |
| 529 | 4 | < 0.1% |
| 521 | 6 | < 0.1% |
| 487 | 18 | |
| 486 | 15 |
attribute5
Real number (ℝ)
| Distinct | 60 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.222669 |
| Minimum | 1 |
|---|---|
| Maximum | 98 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 972.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 8 |
| median | 10 |
| Q3 | 12 |
| 95-th percentile | 58 |
| Maximum | 98 |
| Range | 97 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 15.943028 |
|---|---|
| Coefficient of variation (CV) | 1.1209589 |
| Kurtosis | 12.152135 |
| Mean | 14.222669 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 3.4836794 |
| Sum | 1770637 |
| Variance | 254.18014 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 8 | 22145 | |
| 9 | 13597 | |
| 11 | 12792 | |
| 10 | 11480 | |
| 7 | 11271 | |
| 12 | 9843 | |
| 6 | 8542 | 6.9% |
| 13 | 6006 | 4.8% |
| 14 | 3517 | 2.8% |
| 5 | 3429 | 2.8% |
| Other values (50) | 21872 |
| Value | Count | Frequency (%) |
| 1 | 173 | 0.1% |
| 2 | 203 | 0.2% |
| 3 | 815 | 0.7% |
| 4 | 933 | 0.7% |
| 5 | 3429 | 2.8% |
| 6 | 8542 | 6.9% |
| 7 | 11271 | |
| 8 | 22145 | |
| 9 | 13597 | |
| 10 | 11480 |
| Value | Count | Frequency (%) |
| 98 | 224 | 0.2% |
| 95 | 672 | |
| 94 | 224 | 0.2% |
| 92 | 448 | |
| 91 | 215 | 0.2% |
| 90 | 357 | |
| 89 | 224 | 0.2% |
| 78 | 224 | 0.2% |
| 70 | 224 | 0.2% |
| 68 | 448 |
attribute6
Real number (ℝ)
| Distinct | 44838 |
|---|---|
| Distinct (%) | 36.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 260172.66 |
| Minimum | 8 |
|---|---|
| Maximum | 689161 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 972.7 KiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 46 |
| Q1 | 221452 |
| median | 249799.5 |
| Q3 | 310266 |
| 95-th percentile | 443047.8 |
| Maximum | 689161 |
| Range | 689153 |
| Interquartile range (IQR) | 88814 |
Descriptive statistics
| Standard deviation | 99151.079 |
|---|---|
| Coefficient of variation (CV) | 0.38109723 |
| Kurtosis | 1.9077772 |
| Mean | 260172.66 |
| Median Absolute Deviation (MAD) | 35382.5 |
| Skewness | -0.37528461 |
| Sum | 3.2389935 × 1010 |
| Variance | 9.8309364 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 31 | 777 | 0.6% |
| 44 | 708 | 0.6% |
| 27 | 636 | 0.5% |
| 26 | 520 | 0.4% |
| 29 | 441 | 0.4% |
| 36 | 337 | 0.3% |
| 35 | 290 | 0.2% |
| 52 | 282 | 0.2% |
| 45 | 246 | 0.2% |
| 28 | 216 | 0.2% |
| Other values (44828) | 120041 |
| Value | Count | Frequency (%) |
| 8 | 19 | < 0.1% |
| 9 | 172 | |
| 12 | 51 | < 0.1% |
| 18 | 36 | < 0.1% |
| 19 | 30 | < 0.1% |
| 20 | 6 | < 0.1% |
| 21 | 58 | < 0.1% |
| 23 | 71 | 0.1% |
| 24 | 123 | |
| 25 | 184 |
| Value | Count | Frequency (%) |
| 689161 | 1 | |
| 689062 | 1 | |
| 689035 | 1 | |
| 688964 | 1 | |
| 688952 | 2 | |
| 687901 | 1 | |
| 687802 | 1 | |
| 687775 | 1 | |
| 687706 | 1 | |
| 687694 | 2 |
attribute7
Real number (ℝ)
High correlation Skewed Zeros
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.29252815 |
| Minimum | 0 |
|---|---|
| Maximum | 832 |
| Zeros | 123036 |
| Zeros (%) | 98.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 972.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 832 |
| Range | 832 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 7.436924 |
|---|---|
| Coefficient of variation (CV) | 25.422934 |
| Kurtosis | 6876.273 |
| Mean | 0.29252815 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 73.476456 |
| Sum | 36418 |
| Variance | 55.307838 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 0 | 123036 | |
| 8 | 793 | 0.6% |
| 16 | 397 | 0.3% |
| 24 | 65 | 0.1% |
| 48 | 36 | < 0.1% |
| 32 | 35 | < 0.1% |
| 128 | 23 | < 0.1% |
| 40 | 20 | < 0.1% |
| 176 | 20 | < 0.1% |
| 6 | 13 | < 0.1% |
| Other values (18) | 56 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 123036 | |
| 6 | 13 | < 0.1% |
| 8 | 793 | 0.6% |
| 16 | 397 | 0.3% |
| 22 | 2 | < 0.1% |
| 24 | 65 | 0.1% |
| 32 | 35 | < 0.1% |
| 40 | 20 | < 0.1% |
| 48 | 36 | < 0.1% |
| 56 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 832 | 2 | < 0.1% |
| 744 | 1 | < 0.1% |
| 736 | 4 | < 0.1% |
| 496 | 1 | < 0.1% |
| 424 | 1 | < 0.1% |
| 312 | 5 | < 0.1% |
| 272 | 2 | < 0.1% |
| 240 | 1 | < 0.1% |
| 216 | 1 | < 0.1% |
| 176 | 20 |
attribute8
Real number (ℝ)
High correlation Skewed Zeros
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.29252815 |
| Minimum | 0 |
|---|---|
| Maximum | 832 |
| Zeros | 123036 |
| Zeros (%) | 98.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 972.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 832 |
| Range | 832 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 7.436924 |
|---|---|
| Coefficient of variation (CV) | 25.422934 |
| Kurtosis | 6876.273 |
| Mean | 0.29252815 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 73.476456 |
| Sum | 36418 |
| Variance | 55.307838 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 0 | 123036 | |
| 8 | 793 | 0.6% |
| 16 | 397 | 0.3% |
| 24 | 65 | 0.1% |
| 48 | 36 | < 0.1% |
| 32 | 35 | < 0.1% |
| 128 | 23 | < 0.1% |
| 40 | 20 | < 0.1% |
| 176 | 20 | < 0.1% |
| 6 | 13 | < 0.1% |
| Other values (18) | 56 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 123036 | |
| 6 | 13 | < 0.1% |
| 8 | 793 | 0.6% |
| 16 | 397 | 0.3% |
| 22 | 2 | < 0.1% |
| 24 | 65 | 0.1% |
| 32 | 35 | < 0.1% |
| 40 | 20 | < 0.1% |
| 48 | 36 | < 0.1% |
| 56 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 832 | 2 | < 0.1% |
| 744 | 1 | < 0.1% |
| 736 | 4 | < 0.1% |
| 496 | 1 | < 0.1% |
| 424 | 1 | < 0.1% |
| 312 | 5 | < 0.1% |
| 272 | 2 | < 0.1% |
| 240 | 1 | < 0.1% |
| 216 | 1 | < 0.1% |
| 176 | 20 |
attribute9
Real number (ℝ)
Skewed Zeros
| Distinct | 65 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.451524 |
| Minimum | 0 |
|---|---|
| Maximum | 18701 |
| Zeros | 97358 |
| Zeros (%) | 78.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 972.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 11 |
| Maximum | 18701 |
| Range | 18701 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 191.42562 |
|---|---|
| Coefficient of variation (CV) | 15.37367 |
| Kurtosis | 4050.1905 |
| Mean | 12.451524 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 49.899278 |
| Sum | 1550140 |
| Variance | 36643.769 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 97358 | |
| 1 | 9436 | 7.6% |
| 2 | 3722 | 3.0% |
| 3 | 2327 | 1.9% |
| 4 | 1396 | 1.1% |
| 6 | 797 | 0.6% |
| 7 | 774 | 0.6% |
| 5 | 735 | 0.6% |
| 8 | 733 | 0.6% |
| 10 | 641 | 0.5% |
| Other values (55) | 6575 | 5.3% |
| Value | Count | Frequency (%) |
| 0 | 97358 | |
| 1 | 9436 | 7.6% |
| 2 | 3722 | 3.0% |
| 3 | 2327 | 1.9% |
| 4 | 1396 | 1.1% |
| 5 | 735 | 0.6% |
| 6 | 797 | 0.6% |
| 7 | 774 | 0.6% |
| 8 | 733 | 0.6% |
| 9 | 335 | 0.3% |
| Value | Count | Frequency (%) |
| 18701 | 5 | < 0.1% |
| 10137 | 4 | < 0.1% |
| 7226 | 5 | < 0.1% |
| 2794 | 6 | < 0.1% |
| 2637 | 84 | |
| 2522 | 179 | |
| 2270 | 5 | < 0.1% |
| 2269 | 1 | < 0.1% |
| 1864 | 5 | < 0.1% |
| 1165 | 118 |
Interactions
Correlations
| attribute1 | attribute2 | attribute3 | attribute4 | attribute5 | attribute6 | attribute7 | attribute8 | attribute9 | failure | |
|---|---|---|---|---|---|---|---|---|---|---|
| attribute1 | 1.000 | -0.001 | 0.002 | 0.002 | -0.005 | -0.003 | -0.002 | -0.002 | -0.003 | 0.009 |
| attribute2 | -0.001 | 1.000 | -0.019 | 0.225 | -0.027 | -0.077 | 0.109 | 0.109 | -0.029 | 0.096 |
| attribute3 | 0.002 | -0.019 | 1.000 | 0.121 | 0.107 | 0.070 | -0.010 | -0.010 | 0.390 | 0.000 |
| attribute4 | 0.002 | 0.225 | 0.121 | 1.000 | -0.021 | 0.012 | 0.163 | 0.163 | 0.049 | 0.112 |
| attribute5 | -0.005 | -0.027 | 0.107 | -0.021 | 1.000 | 0.084 | -0.020 | -0.020 | 0.034 | 0.007 |
| attribute6 | -0.003 | -0.077 | 0.070 | 0.012 | 0.084 | 1.000 | -0.016 | -0.016 | 0.090 | 0.012 |
| attribute7 | -0.002 | 0.109 | -0.010 | 0.163 | -0.020 | -0.016 | 1.000 | 1.000 | -0.018 | 0.114 |
| attribute8 | -0.002 | 0.109 | -0.010 | 0.163 | -0.020 | -0.016 | 1.000 | 1.000 | -0.018 | 0.114 |
| attribute9 | -0.003 | -0.029 | 0.390 | 0.049 | 0.034 | 0.090 | -0.018 | -0.018 | 1.000 | 0.000 |
| failure | 0.009 | 0.096 | 0.000 | 0.112 | 0.007 | 0.012 | 0.114 | 0.114 | 0.000 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| date | device | failure | attribute1 | attribute2 | attribute3 | attribute4 | attribute5 | attribute6 | attribute7 | attribute8 | attribute9 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2015-01-01 | S1F01085 | 0 | 215630672 | 56 | 0 | 52 | 6 | 407438 | 0 | 0 | 7 |
| 1 | 2015-01-01 | S1F0166B | 0 | 61370680 | 0 | 3 | 0 | 6 | 403174 | 0 | 0 | 0 |
| 2 | 2015-01-01 | S1F01E6Y | 0 | 173295968 | 0 | 0 | 0 | 12 | 237394 | 0 | 0 | 0 |
| 3 | 2015-01-01 | S1F01JE0 | 0 | 79694024 | 0 | 0 | 0 | 6 | 410186 | 0 | 0 | 0 |
| 4 | 2015-01-01 | S1F01R2B | 0 | 135970480 | 0 | 0 | 0 | 15 | 313173 | 0 | 0 | 3 |
| 5 | 2015-01-01 | S1F01TD5 | 0 | 68837488 | 0 | 0 | 41 | 6 | 413535 | 0 | 0 | 1 |
| 6 | 2015-01-01 | S1F01XDJ | 0 | 227721632 | 0 | 0 | 0 | 8 | 402525 | 0 | 0 | 0 |
| 7 | 2015-01-01 | S1F023H2 | 0 | 141503600 | 0 | 0 | 1 | 19 | 494462 | 16 | 16 | 3 |
| 8 | 2015-01-01 | S1F02A0J | 0 | 8217840 | 0 | 1 | 0 | 14 | 311869 | 0 | 0 | 0 |
| 9 | 2015-01-01 | S1F02DZ2 | 0 | 116440096 | 0 | 323 | 9 | 9 | 407905 | 0 | 0 | 164 |
| date | device | failure | attribute1 | attribute2 | attribute3 | attribute4 | attribute5 | attribute6 | attribute7 | attribute8 | attribute9 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 124484 | 2015-11-02 | W1F0SJJ2 | 0 | 47525320 | 0 | 0 | 0 | 12 | 357421 | 0 | 0 | 0 |
| 124485 | 2015-11-02 | Z1F0GB8A | 0 | 92823192 | 0 | 0 | 0 | 9 | 357127 | 0 | 0 | 0 |
| 124486 | 2015-11-02 | Z1F0GE1M | 0 | 222878704 | 0 | 0 | 0 | 10 | 349826 | 0 | 0 | 0 |
| 124487 | 2015-11-02 | Z1F0KJDS | 0 | 79883648 | 0 | 0 | 0 | 11 | 358121 | 0 | 0 | 0 |
| 124488 | 2015-11-02 | Z1F0KKN4 | 0 | 218765712 | 0 | 0 | 0 | 9 | 353525 | 0 | 0 | 0 |
| 124489 | 2015-11-02 | Z1F0MA1S | 0 | 18310224 | 0 | 0 | 0 | 10 | 353705 | 8 | 8 | 0 |
| 124490 | 2015-11-02 | Z1F0Q8RT | 0 | 172556680 | 96 | 107 | 4 | 11 | 332792 | 0 | 0 | 13 |
| 124491 | 2015-11-02 | Z1F0QK05 | 0 | 19029120 | 4832 | 0 | 0 | 11 | 350410 | 0 | 0 | 0 |
| 124492 | 2015-11-02 | Z1F0QL3N | 0 | 226953408 | 0 | 0 | 0 | 12 | 358980 | 0 | 0 | 0 |
| 124493 | 2015-11-02 | Z1F0QLC1 | 0 | 17572840 | 0 | 0 | 0 | 10 | 351431 | 0 | 0 | 0 |
Duplicate rows
Most frequently occurring
| date | device | failure | attribute1 | attribute2 | attribute3 | attribute4 | attribute5 | attribute6 | attribute7 | attribute8 | attribute9 | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2015-07-10 | S1F0R4Q8 | 0 | 192721392 | 0 | 0 | 0 | 8 | 213700 | 0 | 0 | 0 | 2 |